package com.tm.mapper;

import com.tm.pojo.vo.BannerVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author xiaobai
 * @create 2022-12-16 20:02
 */
@Mapper
public interface BannerMapper {
    @Select("SELECT " +
                 "banner_id AS bannerId, " +
                 "banner_type AS bannerTypeId, " +
                 "banner_img AS bannerImg " +
            "FROM " +
                 "t_banner " +
            "WHERE " +
                 "banner_end_time >  UNIX_TIMESTAMP(NOW())")
    List<BannerVo> carouselBanner();
}
